package com.woniu.darryringmall.front.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.woniu.darryringmall.front.entity.OrderItems;
import com.woniu.darryringmall.front.entity.ViewOrder;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ViewOrderMapper extends BaseMapper<ViewOrder> {

    @Select("select * from mall_view_order where id=#{orderid}")
    List<ViewOrder> getByOrderId(int orderid);

    @Select("select * from mall_view_order where userid=#{userid}")
    List<ViewOrder> getByUserId(int userid);

    @Select("select * from mall_view_order where status=3")
    List<ViewOrder> getDeletedOrders();
}
